select * from products where pro_name like '%all%dresses%' or pro_des like '%all%dresses%'union all select * from products where (pro_name like '%all%' or pro_des like '%all%') or(pro_name like '%dresses%' or pro_des like '%dresses%') and (pro_name not like '%all%dresses%' or pro_des not like '%all%dresses%')
Pick ups and Embroidery Accent Brown Quinceanera Gowns Dresses
Appliqued Sweetheart Organza Yellow Green Quinceanera Gown Dress
Dark Purple Halter Embroidery Pick ups Quinceanera Dresses Gowns
Blue Ball Gown Organza Dresses for 15 with Appliques and Ruffles
Blue Ball Gown Organza Dresses for A Quinceanera with Appliques
Appliqued and Ruffled Organza Lilac Quinceanera Gown Dresses
Purple Ball Gown Sweetheart Quinces Dresses with Appliques 2013
Trendy Ball Gown Zebra Print Multi-colored Quinceanera Dresses
Traditional Ball Gown Floor-length Blue Quinceanera Dresses
Haltered V-neck Yellow Puffy Ball Gown Sweet Sixteen Dresses
Emerald Green Strapless Ball Gown Taffeta Quinceanera Dresses
Royal Blue Sweetheart Beading Quinceanera Dress with Rosettes
Multi-color Leopard Print Quinceanera Dress V-neck Beading
Strapless Embroidery and Beading Quinceanera Dress Wine Red
Full Length Beading Strapless Aqua Blue Quinceanera Dress Cheap
Embroidered Blue Ball Gown Quinces Dresses with Strapless Ruffles
Cheap Ball Gown Sweetheart Beaded Purple Sweet 16 Dresses
Elegant Ball Gown Aquamarine Sweet 15 Dresses with Rhinestones
Plus Size Appliqued Sweet 16 Dress in Dark Green with Pick Ups
Custom Made Appliqued Green Sweet 15 Dresses with Pick Ups
Fabulous Corset Ruffled Appliqued Colorful Quinces Dresses
Baby Blue and White Strapless Dress for Quince with Embroidery
Long Sleeves Appliqued Red Quinceanera Dress with Black Hem
Popular Ball Gown Light Purple Ruffled Beaded Sweet 16 Dresses
Two-toned Sweetheart Ruffled Beaded Sweet Sixteen Dresses
Plus Size Baby Blue and White Appliqued Quinceanera Dresses
Elegant Ball Gown Strapless Aqua Blue Beaded Sweet 16 Dresses
Aquamarine One Shoulder Beaded Appliqued Dress for Quince
Customized Ball Gown Appliqued Olive Green Sweet 16 Dresses
Modernist Leopard Print Multi-colored Dresses for Sweet 15